package com.neudu.glsb.mapper;

import com.neudu.glsb.pojo.SalesRecords;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
* @author Lenovo
* @description 针对表【sales_records(销售记录信息)】的数据库操作Mapper
* @createDate 2025-04-16 22:28:32
* @Entity com.neudu.glsb.pojo.SalesRecords
*/
public interface SalesRecordsMapper extends BaseMapper<SalesRecords> {
    @Select("SELECT DATE(transaction_date) as date, SUM(amount) as total_amount FROM sales_record GROUP BY DATE(transaction_date)")
    List<Map<String, Object>> getDailySales();
}




